A real-time concurrency control algorithm: Use of multiversion and precedence relationships
نویسندگان
چکیده
This paper proposes a multiversion concurrency control algorithm for real-time databases. Based on a priority cognitive algorithm commonly used in real-time processing, the algorithm resolves data connicts among connict-ing transactions in favor of the urgent transactions, i.e., those with higher priority. Our algorithm is expected to minimize the transactions missing those deadlines and increase the degree of transaction concurrency by using precedence relationships and multiple versions. In the algorithm, a precedence relationship, which implies a serialization order among con-icting transactions, is utilized to resolve data connicts. By exploiting precedence relationships, our algorithm can avoid deadlocks, and dynamically determine the abortion of lower priority transactions depending on the likelihood of roll-backs and the amount of the work done by the low priority transaction.
منابع مشابه
Resolving Data Conflicts with Multiple Versions and Precedence Relationships in Real-Time Databases
We propose a multiversion concurrency control algorithm for real-time databases. Based on a priority cognitive algorithm commonly used in real-time processing, the proposed algorithm resolves data connicts among transactions in favor of the urgent transactions, i.e., those with higher priority. Our algorithm increases the degree of transaction concurrency while minimizing the transactions that ...
متن کاملAnalysis of Real-Time Multi version Concurrency Control Algorithms using Serialisability Graphs
57 ABSTRACT This paper analyses the correctness of Multiversion Concurrency Control(MVCC) algorithms that are commonly deployed in Realtime Databases. Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. MVCC Algori...
متن کاملReal-time Multiversion Repeatable Read Isolation Level
Concurrency control is the activity of synchronizing database operations by concurrently executing transactions on a shared database. We examine the problem of concurrency control when the database supports multiple versions of the data. Multiversion concurrency control is used in order to improve the level of achievable concurrency. The goal is to produce an execution that has the same effect ...
متن کاملReal-time Optimistic Concurrency Control based on Transaction Finish Degree
Concurrency control is one of the main issues in the studies of real-time database systems. Optimistic concurrency control algorithms have the attractive properties of being non-blocking and deadlock-free. However, they have the problems of late conflict detection and transaction restarts. Although the number of transaction restarts is reduced by dynamic adjustment of serialization order in rea...
متن کاملMultiversion Locking Protocol with Freezing for Secure Real-Time Database Systems
Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. Recently, security has become another important issue in many real-time applications. In many systems, sensitive information is shared by multiple users with diff...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- Journal of Systems Architecture
دوره 44 شماره
صفحات -
تاریخ انتشار 1997